Example: Find members by state or join date
This query extracts individual members who live in Texas or those who joined between 1993 and 1997, eliminating duplicates when the same rows are returned by the multiple subqueries.
- Browse to IQA.
- Select Query from the drop-down list and select New.
- Select your sources:
- Browse to the Common folder containing business objects.
- Select Contact.
- Define the filtering rules:
- Select the Filters tab.
- Select Mode: Advanced.
- Filter on MemberType:
- Property: MemberType
- Comparison: Equal
- Value:Member
- Add the filter.
- Filter on StateProvince.
- Property: StateProvince
- Comparison: Equal
- Value: TX
- Add the filter.
- Select Add Filter.
- Select operator OR from the drop-down list.
- Filter on MemberType equal to Member:
- Property: MemberType
- Comparison: Equal
- Value: Member
- Add the filter.
- Filter on Join Dates between.
- Property: Join Date
- Comparison: Between
- Value: "1/1/1993","12/31/1997"
- Add the filter.
- Define the columns that display in the output:
- Select the Display tab.
- Select the Only display unique results option.
- Select the following columns: Id, StateProvince, Join Date.
Note: A default list of columns displays when you select the Display tab. Deselect the columns you do not need. If a column you need is not in the default list, select All from the View drop-down list and scroll down the page to select the desired column.
- Using the Order drop-down list, assign
- ID Order 1
- StateProvince Order 2
- Join Date Order 3
- Specify the sorting priority:
- Select the Sorting tab.
- Sort the results by Id.
- Add your selection.
- Save your settings.
- Run the query.